package chaohao.mybatis.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import aszm.chahaospider.parser.chahao.bean.Tmp_City;

public interface TmpCityMapper {
	/**
	 * @param url
	 *            拼接的Url
	 * @return
	 */
	@Select("SELECT tb_city.id AS id,tb_provice.`name` AS provice," + "tb_city.`name` AS city,"
			+ "CONCAT(#{baseurl,jdbcType=VARCHAR},tb_provice.url,\"/\",tb_city.url) AS url"
			+ " FROM tb_city,tb_provice " + "WHERE tb_city.provice_id = tb_provice.id " + "ORDER BY tb_city.id ASC")
	List<Tmp_City> selectAll(String baseurl);
}
